﻿using System;

namespace edowork.com.Model
{
    #region productInfo

    [Serializable]
    public class productInfo
    {
        #region Private fields

        protected string _productcode = String.Empty;
        protected string _productname = String.Empty;
        protected string _productshortname = String.Empty;
        protected string _goodsclassid = String.Empty;
        protected string _goodsunitid = String.Empty;
        protected string _goodsspecid = String.Empty;
        protected string _stackid = String.Empty;
        protected string _guardid = String.Empty;
        protected decimal _maxqty;
        protected decimal _minqty;
        protected string _sysdate = String.Empty;

        #endregion

        public productInfo() { }

        #region Public Properties

        public string Productcode
        {
            get { return _productcode; }
            set { _productcode = value; }
        }

        public string Productname
        {
            get { return _productname; }
            set { _productname = value; }
        }

        public string Productshortname
        {
            get { return _productshortname; }
            set { _productshortname = value; }
        }

        public string Goodsclassid
        {
            get { return _goodsclassid; }
            set { _goodsclassid = value; }
        }

        public string Goodsunitid
        {
            get { return _goodsunitid; }
            set { _goodsunitid = value; }
        }

        public string Goodsspecid
        {
            get { return _goodsspecid; }
            set { _goodsspecid = value; }
        }

        public string Stackid
        {
            get { return _stackid; }
            set { _stackid = value; }
        }

        public string Guardid
        {
            get { return _guardid; }
            set { _guardid = value; }
        }

        public decimal Maxqty
        {
            get { return _maxqty; }
            set { _maxqty = value; }
        }

        public decimal Minqty
        {
            get { return _minqty; }
            set { _minqty = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into product(Productcode,Productname,Productshortname,Goodsclassid,Goodsunitid,Goodsspecid,Stackid,Guardid,Maxqty,Minqty,Sysdate) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},{9},'{10}')";
        }

        #endregion

    }

    #endregion
}

